UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'giQ67tC5la9N/8Qzy31pf2NBZVQV+X6iGUFfLGrlPGs='
WHERE
key_id = '05982f987805725c069ee6f28c029e2039743bce23d7509e132ee3f0f0dbab25'
AND (
token = 'giQ67tC5la9N/8Qzy31pf2NBZVQV+X6iGUFfLGrlPGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)