UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M9d6JxrqykJSgAIRxJAwuCTu17mTsHVpiT/9MuLY9cU='
WHERE
key_id = 'e6123ac8c80b1ad3b76fa3abf60cdb875fb52fcf9413ce76c2973c01d345f920'
AND (
token = 'M9d6JxrqykJSgAIRxJAwuCTu17mTsHVpiT/9MuLY9cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)