UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KSq1iRIfMFuJmuK5do/wh1OeV4zbe5Gukv4EstDC/zE='
WHERE
key_id = 'c297cfbe8f275b97b7901c0e9c782c72bfbdf708ebb5ab2739386cc25fb29066'
AND (
token = 'KSq1iRIfMFuJmuK5do/wh1OeV4zbe5Gukv4EstDC/zE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)