UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1393KVKWp4AvuclwXxmP/KN6lyDbpHADH504fv2Y9tM='
WHERE
key_id = 'b28b96e2de16bf6414b77e01fc17c8c4358fc9d9f3117b71c54878fa1e7f7a1e'
AND (
token = '1393KVKWp4AvuclwXxmP/KN6lyDbpHADH504fv2Y9tM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)