UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8d500xtGXTJqUBzh7pWQYjSijizAIsN4uPG+6sawk8Y='
WHERE
key_id = 'a19770a9e61867db2c262a8b4a21707f207e1bc765d3f0fd2bab1ce01c3a519b'
AND (
token = '8d500xtGXTJqUBzh7pWQYjSijizAIsN4uPG+6sawk8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)