UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qC48HuwEWhzpyQ15urfcgFlwHSBmky4qjwfq+M9KpUc='
WHERE
key_id = 'a5657cfdb9f2f18e715a8f51ce9237d6010ba63b50f5f798c7edbdef6571857e'
AND (
token = 'qC48HuwEWhzpyQ15urfcgFlwHSBmky4qjwfq+M9KpUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)