UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'odEnG4W6M4SHhaj5U6HoUT9pcRioeAVxZq4pgO/BkoU='
WHERE
key_id = '1a9bf73159093c9e3c857a5829bd1861184a1b4d7fb6d3e8747eb4778e8d2a96'
AND (
token = 'odEnG4W6M4SHhaj5U6HoUT9pcRioeAVxZq4pgO/BkoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)