UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n+tGWpNDEN16pQg+v1nPehfIMahuwNWSAnMP7RHy9Zs='
WHERE
key_id = 'a7dd0d4d16a4681fd95a2cc14849370f30bb9a8f59e5e68048b59f7493b24c3e'
AND (
token = 'n+tGWpNDEN16pQg+v1nPehfIMahuwNWSAnMP7RHy9Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)