UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1b4xvEAA0XavpMc7HOZx3FIGVTFtZXJWSkaK60QzA4c='
WHERE
key_id = '0086dfc2729a6caabca958165cdfdaffb52300aa2abe4d69fa8eda531fcb2d2d'
AND (
token = '1b4xvEAA0XavpMc7HOZx3FIGVTFtZXJWSkaK60QzA4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)