UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXvC4JO3bdY7P57T8EPPdh0ik0gymnE2UkmFG1p8BA0='
WHERE
key_id = 'e786f96f075ed3ae82978e8b38d5dc9e0da2c7a7293c34ab7820c7e6dbd410f4'
AND (
token = 'zXvC4JO3bdY7P57T8EPPdh0ik0gymnE2UkmFG1p8BA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)