UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yx/KZfTNZw3178L4Z/2LqxvwoqPbPut8AkR5m3tT6GU='
WHERE
key_id = '100778fdca713b2cb30d5d293a3c5955b7860c6335925f2c9badc9c5ec282f5b'
AND (
token = 'yx/KZfTNZw3178L4Z/2LqxvwoqPbPut8AkR5m3tT6GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)