UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCwM+z662eOV8B++QtnUoil5+ZJmUO9KdU1I0RYyXUk='
WHERE
key_id = 'd0387f5e19e78ab4aedec9ce44c90356c8f863a17749070f5b59a9eaad6efebd'
AND (
token = 'NCwM+z662eOV8B++QtnUoil5+ZJmUO9KdU1I0RYyXUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)