UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7colNOsONZOE8l77B7SjUYP9w/lZnsonvD55G/+iLNw='
WHERE
key_id = '564e8b38d5610513ec6ca7648cc2019790850cc0e026f8acaa448c1a825e5a4b'
AND (
token = '7colNOsONZOE8l77B7SjUYP9w/lZnsonvD55G/+iLNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)