UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4ECzv4Cdhkjo4IiWVZSvNdg5XZth93NnXB4KUz712o='
WHERE
key_id = 'b2c2063708917c9e42510f8cf91465167f9bad7b32eefa129adfb235ad5d1945'
AND (
token = 'E4ECzv4Cdhkjo4IiWVZSvNdg5XZth93NnXB4KUz712o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)