UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBZLlDwbMtpsIlW3YZC3AHd3tapS1lC/9uWOGtzXOig='
WHERE
key_id = 'e92961c3f4aa06d9f79df8f61d19a823a93ee9126126892a060f3aaaf8ed0014'
AND (
token = 'pBZLlDwbMtpsIlW3YZC3AHd3tapS1lC/9uWOGtzXOig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)