UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/HQ4a2cSm2erfrI5OuRcItKXjWammMjd1EQuwAifWok='
WHERE
key_id = 'e01dd4153509d22ce7272acfcbae90295a7da53785c9502628e88a6a738f1ee5'
AND (
token = '/HQ4a2cSm2erfrI5OuRcItKXjWammMjd1EQuwAifWok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)