UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PIZkwbq9LB+XI2XDApZE5S2UgoclfgYMvsVNxRUKKJk='
WHERE
key_id = 'd563d7b55011afc4f72a1562146054ad57dbdc9f12f33d60b7dc3afafe8861bd'
AND (
token = 'PIZkwbq9LB+XI2XDApZE5S2UgoclfgYMvsVNxRUKKJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)