UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'knu344WFKWfvm9GKzZFBci9jWbJ1/7xRM0Ew2otztFI='
WHERE
key_id = 'b7a3d36bca88dfd255f5cb1897247d1165607a11d72013c34913307e7818f07c'
AND (
token = 'knu344WFKWfvm9GKzZFBci9jWbJ1/7xRM0Ew2otztFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)