UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9E67QSIn8K8HorwOL/VChJCc2Fx6amcK2ScLsRZBOQ='
WHERE
key_id = '642665db3f1bc91bcf6a3ffe1d4bf1b392470bd324784a29b4b4352960ddc73e'
AND (
token = 'B9E67QSIn8K8HorwOL/VChJCc2Fx6amcK2ScLsRZBOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)