UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GH786DmCMSEZojmvBmz58Wg64skA7mnla5uck9Wz/E='
WHERE
key_id = 'bb9531264f8243bdae3a9ff73f1cf2460c80270f8879fe312a44630c7024ccf1'
AND (
token = '3GH786DmCMSEZojmvBmz58Wg64skA7mnla5uck9Wz/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)