UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNharoi0yyrlekinsSxojWywq62d7JdmoPuUpDa/h+w='
WHERE
key_id = 'a0dea44b9c54eec348fa6e8d4326cbc6fa11e0cc9c2d3a1254d23f51c5bf8600'
AND (
token = 'RNharoi0yyrlekinsSxojWywq62d7JdmoPuUpDa/h+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)