UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wqoxuZuQZunS+ERAPVQDqA/yVTdTcQbrCe755BpNCM='
WHERE
key_id = '478326e5973f1a115971037798c485e89c7d9b9e88ebfe891b532b4168b21019'
AND (
token = '8wqoxuZuQZunS+ERAPVQDqA/yVTdTcQbrCe755BpNCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)