UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZMVJEpBwugYrpOmH6kLRV050uNonTMwoix/+lM/xmU='
WHERE
key_id = '946456d11ee103485cfaa0b59fd6e3ef01008956d8e089967e9999e2f7521a07'
AND (
token = 'ZZMVJEpBwugYrpOmH6kLRV050uNonTMwoix/+lM/xmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)