UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WPi98RL7ZhiSVoFof25iEzKsXm1Y1Q3E1tHaNVxY9F8='
WHERE
key_id = '266f82ad0f4b0038f130d37a96872c5ec4e49b2f5f17f1875fe78992f61197f3'
AND (
token = 'WPi98RL7ZhiSVoFof25iEzKsXm1Y1Q3E1tHaNVxY9F8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)