UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPQzi99l0mmTQ0MWPVp+mGojF/0KqSVMoOcgIYrO3KU='
WHERE
key_id = '0bf86953c654654599ebf23c53549dc3e342a31b1c684680a13fb33be8dfdadc'
AND (
token = 'sPQzi99l0mmTQ0MWPVp+mGojF/0KqSVMoOcgIYrO3KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)