UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1a8fRJhOXJonJwYgXUu/KBsYAapbwUb6+7yvR82Fssc='
WHERE
key_id = '50141a7e6e5170f3aca9f36910daf98edc666c19c0e20ac4e7b8ee85fb4ef88f'
AND (
token = '1a8fRJhOXJonJwYgXUu/KBsYAapbwUb6+7yvR82Fssc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)