UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7U8ZRicdbOycso/7l8CNcZw/4lEqwUX89B8sTxVrrY='
WHERE
key_id = '0ddf5593d5cb40563c8c1306571ca69ca246b059f035d6adb04937711308a36b'
AND (
token = 'C7U8ZRicdbOycso/7l8CNcZw/4lEqwUX89B8sTxVrrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)