UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'My4K28alMGfKQYtXcNHsbwqPk8f7nNU90RYX8FxF/GQ='
WHERE
key_id = '414ea2662bb8533dcce2afbd6c8f4d340ab0b4f6491a6026b06ffb035c4f814a'
AND (
token = 'My4K28alMGfKQYtXcNHsbwqPk8f7nNU90RYX8FxF/GQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)