UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKxWAnKwxkRmT52PU6tfqL1QU8hxxlCPk2j8Rwa8aZI='
WHERE
key_id = '87c683c2d62b21a9a4444ec12257ac9eae6931fb04dc7d10c319530d1f029f9a'
AND (
token = 'hKxWAnKwxkRmT52PU6tfqL1QU8hxxlCPk2j8Rwa8aZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)