UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sX5WKefZQ1obnOZKjURzVpFSdHL1Jac6d8YEOs97yA4='
WHERE
key_id = '1745b47999279a799e1dd984f128201624be048e7b38b8f326844a1f4c54a60f'
AND (
token = 'sX5WKefZQ1obnOZKjURzVpFSdHL1Jac6d8YEOs97yA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)