UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPrD2+27OyxlD2oeeGR3AEHviHPiLsEDXT9XBmL33yg='
WHERE
key_id = 'fd79dcd8ff080701ecf897ef90870af0a83b7aa67d71891f32861707c7dfe635'
AND (
token = 'NPrD2+27OyxlD2oeeGR3AEHviHPiLsEDXT9XBmL33yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)