UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VGtIx2iAd9d/xH+GcWeOZiiuoME0csecxFRF+9TGJAc='
WHERE
key_id = '169b9eb84cfee054a509b6cd82819f402d54c1446ca741392eeed92472560ef4'
AND (
token = 'VGtIx2iAd9d/xH+GcWeOZiiuoME0csecxFRF+9TGJAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)