UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QTuT05KPnkehHtUXK5ItFm88IY+h8ssVBo2stl7eb6s='
WHERE
key_id = 'bddc78a26740d749259e76a28ea46ef6a192beba7a072f2467b8dd0a50393043'
AND (
token = 'QTuT05KPnkehHtUXK5ItFm88IY+h8ssVBo2stl7eb6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)