UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I6SzZDnued1Il68WMYDzfyQlAyQYvLLca/TNyaV+foM='
WHERE
key_id = '27c51fcf6bdccf776b3628f1cc4dd80b9bed3dec46a76ad4121006e29a3ca0e8'
AND (
token = 'I6SzZDnued1Il68WMYDzfyQlAyQYvLLca/TNyaV+foM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)