UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p2XHsIJSxH6UQ8l+RiDNZ5Aqv77pVv1PHQuC2A1kjwE='
WHERE
key_id = '0dd8a15260aeb9e635e663f465dbf81c1acc81895219ce5fca202222a276be3c'
AND (
token = 'p2XHsIJSxH6UQ8l+RiDNZ5Aqv77pVv1PHQuC2A1kjwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)