UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tY78MPBoH9Q9yAUdY00HIj4E9mAwKNX0y36kgEHTsxk='
WHERE
key_id = '57a4a750a3cf49650b8e2349c777b478038d61558aedaf98a5e35b3a27ecf221'
AND (
token = 'tY78MPBoH9Q9yAUdY00HIj4E9mAwKNX0y36kgEHTsxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)