UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9YBSFgEs4QOqhP0nYHOkIEGP2lD5N6NU3CwvkHHdA8U='
WHERE
key_id = '65f3f3b40c13a9d4741241c68caf9805e06296adeb59e2582923b1263b4a815c'
AND (
token = '9YBSFgEs4QOqhP0nYHOkIEGP2lD5N6NU3CwvkHHdA8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)