UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oEcm5LyMDO2dDVKXTKscE6yiKn9mmh30t+3M2o4v+PE='
WHERE
key_id = 'ded0b2737bbd834c1f9e2221b1da30e9f8dfba504320cf78a6f66b04a2e45a4e'
AND (
token = 'oEcm5LyMDO2dDVKXTKscE6yiKn9mmh30t+3M2o4v+PE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)