UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1HuVn1titZLAEoo1ZemfnB/or4Vg8pf09+w2Ln8X3U8='
WHERE
key_id = 'f18a98b2ff7afba73d99cd38cd9f748bf896a5e9aa2d0b2c8f8f12661ba572ff'
AND (
token = '1HuVn1titZLAEoo1ZemfnB/or4Vg8pf09+w2Ln8X3U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)