UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Jc5kAyuGATxJgZoLaWbiMpWwJHL1LirTus2Ic2QykI='
WHERE
key_id = '99709acd699bd9345f445c212cc2088e262d4ee305420d4dd42c06ed72b601e6'
AND (
token = '5Jc5kAyuGATxJgZoLaWbiMpWwJHL1LirTus2Ic2QykI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)