UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50T3X7dEWWYF8+7eeIAvxEiELuVkCd9rFEcj/PFgNRQ='
WHERE
key_id = '3c4447b6de77ffda185143d444344d57c7dfb53fb53ad9b548c3090e7f2af3a3'
AND (
token = '50T3X7dEWWYF8+7eeIAvxEiELuVkCd9rFEcj/PFgNRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)