UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dRAyhXzJe0J8mz5xiaVRVtr7DAv5lChqUYJeq6BdTEA='
WHERE
key_id = 'e4eaf460496d84b31d1b4ec914a3dd177d64ee67e611a03e12f7e1613c610077'
AND (
token = 'dRAyhXzJe0J8mz5xiaVRVtr7DAv5lChqUYJeq6BdTEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)