UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ErRiKHcn3COrnzYV0Cx1ZiY9vTFyw4D0cEPab4inIwM='
WHERE
key_id = 'ae6119465a45c03db1c5f7e29cc45538dc0a8b06eaf6072acb58c6622253a36a'
AND (
token = 'ErRiKHcn3COrnzYV0Cx1ZiY9vTFyw4D0cEPab4inIwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)