UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QjCtkXuFjLkvXBz5v4oWXZhyWJy+zJUMf0q2JwR0Ijw='
WHERE
key_id = 'aa7cd47f5b92de19a63a0cbf317246a8576df2e6ac046dd6b3e0b43a6c5b74fe'
AND (
token = 'QjCtkXuFjLkvXBz5v4oWXZhyWJy+zJUMf0q2JwR0Ijw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)