UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCkoITkBifo2dbD1tDh1VTeLeMOEFuL+eIzz7I3us8M='
WHERE
key_id = 'f74ab4375e2ff95394045ff69b8edab1d3355cf496ad2ca96a03b8efd640b34d'
AND (
token = 'xCkoITkBifo2dbD1tDh1VTeLeMOEFuL+eIzz7I3us8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)