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