UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dl8VsJv642V8KwWOnVVEbM6TylyVcy0PoVQdTG7voGU='
WHERE
key_id = '59362d7e9e1f170b5920e7c7ece70e9c88c41655d5a5f14b5bb6a33c42421b6e'
AND (
token = 'dl8VsJv642V8KwWOnVVEbM6TylyVcy0PoVQdTG7voGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)